2017-06-08 - 39958 - Service Request - INV140 - output validation #CrystalReportsSupport
Service Request
INV140 - output validation
Problem Summary
Need to validate INV140 report with Production report.
Admin Info
Purpose
|
Need to validate INV140 report with Production report.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
06/08/2017
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
06/08/2017
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan Lakshmanan on 06/08/2017:
I need the following materials added to INV140 - Available Titleist Inventory and to add the following materials in the filter of the report. We have done it before multiple times.
Now, if we add these materials, then the list of materials coming in the output is very low.
11479364 TH7FDMC 4N FITTED DIA MESH NVY CST P12
11479365 TH7FDMC 2S FITTED DIA MESH STN CST P12
11479300 TH7FDMC 1 FITTED DIA MESH WHT CST P12
11479301 TH7FDMC 0 FITTED DIA MESH BLK CST P12
11479362 TH7FDMC 6 FITTED DIA MESH RED CST P12
11479363 TH7FDMC 4R FITTED DIA MESH RYL CST P12
Solution Analysis and Recommendations
1. Need to check filters for both reports.
2. Need to check list of materials in production version as well as developed version.
3. Need to place the report in BI development and inform NEC for promotion after successful validation.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Checked INV140 report, the below list of materials are also filtered in Production report(DataSource Reports > Inventory folder) and missing materials in developed version:
11421811
11421812
11421822
11429087
11429088
11429089
11429090
11429091
11429092
11429093
11429094
11429095
11429096
11429097
11429098
11429099
11429100
11429101
11429393
11429394
11429395
11429396
11429397
11429398
11429399
11429400
11429401
2. After adding the above materials in the filter section, the output matches with production version.
Release Information
None